Package

                pip install xlrd

                pip install openpyxl
              

Code

                import pandas as pd
 
                # read by default 1st sheet of an excel file
                dataframe1 = pd.read_excel('file_example_XLS_10.xls')
                #print(dataframe1)

                for index, row in dataframe1.iterrows():
                    print (index,row)